Overview: Vertical Merge Merge

Use this operation to merge two datasets one below the other.

This operation is not dependant on the timestamp field, and will not merge the timestamp fields into one chronological sequence. The resulting timestamp field will thus contain the timestamps of the first dataset, followed by the timestamps of the second dataset. A new dataset will be created with the left hand dataset at the top of the newly created dataset, and the right hand dataset underneath this.

This operation also allows you to select the fields from the two datasets that you want to include in the new dataset. You need to map the selected fields from the first dataset to that of the second dataset. These fields can only be mapped to fields of the same type, for example integer to integer fields, and double to double fields.

Properties

Category:

Combine

Performance risk:

Low performance risk

Knowledge required:

None

 

Effect on datasets

How many datasets are required to perform this operation?

Two

Does it create a new dataset?

Yes

Can you reconfigure this operation?

Yes

Can you apply this operation to a locked dataset?

Yes

Does it modify the current dataset in any way?

No

Requirements

  • This operation needs two datasets.

  • During merging, all supported field types are mapped between the two datasets. Mapped fields will appear in the same column in the merged dataset. Fields can only be mapped to same data type fields (integer - integer, double - double, string - string and timestamp - timestamp).

Results

  • A new dataset containing the merged and mapped fields from the original datasets.

  • The merged, mapped fields will be listed one below the other.

  • The [Next] and [Finish] buttons will be disabled until all configuration is complete.

  • The values of the original datasets remain the same.


Related topics:

  

CSense 2023- Last updated: June 24,2025